<?php
    include 'functions.php';
    include 'dbconf.php';
    include 'dbopen.php';
?>


<form NAME="theform" ID="theform" action="PHP/clinical_vs_expression_pvalues.php" onSubmit="return selIt();">
<table>
    <h1>Expression vs. Clinical data</h1>

    <tr>
        <td colspan="5">
            Input Clinical Variables: <select NAME="SelectList[]" ID="SelectList" SIZE="10" multiple="multiple" style="width: 800px">

    
            <?php 

                $clinical_var_options = mysql_query(getClinicalVarOptions())
                        or die ("Could not execute query: getClinicalVarOptions" . mysql_error());
                while ($row = mysql_fetch_array($clinical_var_options)) {
                    if ($row['column_name']!= "ind_nbr") {
                        echo "<option value=\"".$row['column_name']."\">".$row['column_name']."</option>";
                    }

                }
                
            ?>
            </select>

        </td>
    </tr>
    <tr>
        <td>
            <input TYPE="BUTTON" VALUE="->" ONCLICK="addIt();"></input>
            <br />
            <input TYPE="BUTTON" VALUE="<-" ONCLICK="delIt();"></input>
        </td>
    </tr>
    <tr>
        <td colspan="5">
            <select NAME="PickList[]" ID="PickList" SIZE="5" multiple="multiple" style="width: 800px">
            <option VALUE="01sel">Selection 01</option>
            </select>
        </td>
    </tr>
    <tr>
        <td>
            <table>
                <tr>
                    <td>

                        Input Genes:
                        <br>
                        <textarea cols="10" rows="10" name="input_gene_sym"></textarea>
                    </td>
                    <td width="7" bgcolor="#FFFFFF"><BR>
                    </td>
                    <td valign="top">
                        Select tissue:
                        <br>
                        <select name="bike_tissue">
                        <?php
                            $options = mysql_query(getTissueTypeOptions())
                                or die ("Could not execute query: " . mysql_error());
                            while ($row = mysql_fetch_array($options)) {
                                echo "<option value=\"".$row['name']."\">".$row['name']."</option>";
                            }
                        ?>
                        </select>
                    </td>
                <tr>
            </table>
        </td>
    </tr>
    <tr>

        <td ALIGN="left">
            <table>
                <tr>
                    <td>
                        <input TYPE="reset" VALUE="Reset All" ONCLICK="javascript: window.location.href = 'index.php?block=expVsClin'">
                    </td>
                    <td>
                    <td width="15" bgcolor="#FFFFFF"><BR>
                    </td>
                    <td>
                        <input TYPE="submit" VALUE="Submit">
                    </td>
                </tr>
            </table>
        </td>
    </tr>
</table>
</form>
<?php
    include 'dbclose.php';
?>